
	
/****** Object:  Stored Procedure [sapro].GiaoDichUpdate    Script Date: Thursday, March 18, 2010 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spGiaoDichUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [sapro].[spGiaoDichUpdate]
GO
			
	
	

	
/******************************************************************************
**		File: 
**		Name: [sapro].spGiaoDichUpdate
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 3/18/2010 5:03:58 PM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE [sapro].spGiaoDichUpdate
	@Mobile nvarchar(20), 
	@NgayGD datetime, 
	@GioGD datetime, 
	@SoDiemTruoc int, 
	@SoDiemGD int, 
	@SoDiemSau int, 
	@NoiDung nvarchar(255) 
AS

UPDATE [sapro].[GiaoDich] SET
	[SoDiemTruoc] = @SoDiemTruoc,
	[SoDiemGD] = @SoDiemGD,
	[SoDiemSau] = @SoDiemSau,
	[NoiDung] = @NoiDung
WHERE
	[Mobile] = @Mobile
	AND [NgayGD] = @NgayGD
	AND [GioGD] = @GioGD

GO

